﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Search.aspx.vb" Inherits="Dabke.Search" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

  <asp:TextBox ID="TB_Search" runat="server" ></asp:TextBox>
<asp:Button ID="Btn_Search" runat="server" Text="Search" />

            <br />
  <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" 
        AutoGenerateColumns="False" Width="100%" AllowSorting="True" 
        CellPadding="4" ForeColor="#333333">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="Dabka_Name" HeaderText="Dabke Name" />
            <asp:HyperLinkField DataNavigateUrlFields="ID" 
                DataNavigateUrlFormatString="Dabka_Detail.aspx?ID={0}" DataTextField="Dabka_Country" 
                HeaderText="Country" SortExpression="ID" >
            <ItemStyle HorizontalAlign="Left" VerticalAlign="Middle" />
            </asp:HyperLinkField>
            <asp:BoundField DataField="Added time" HeaderText="Added Time" 
                SortExpression="Added time" >
            <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:BoundField DataField="Added by" HeaderText="Added by" 
                SortExpression="Added by" >
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <EmptyDataTemplate>
            Sorry No Data Found !!!
        </EmptyDataTemplate>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        
        
        SelectCommand="SELECT [ID], [Dabka_Name], [Dabka_Country], [Dabka_Description], [Dabka_Ryhthm], [Dabka_Members], [Dabka_Gender], [Dabka_Picture], [Teach Dabke] AS Teach_Dabke, [Added time] , [How to learn] AS How_to_learn, [Added by] , [Dabka_URL] FROM [Dabka]">
    </asp:SqlDataSource>
</asp:Content>
